Work Sample

Author

Katherine Mead


Introduction

  • Valor Collegiate Academies has a nationwide leadership training program that currently serves 42 schools and over 10,000 students. Valor reached out to me as a contractor because they needed more user-friendly software for managing the data for the program’s success. Their ideal solution would connect teacher-level data to school-level data, and ultimately school-level data to the superadmin level where Valor’s leadership coaches could monitor school progress. The solution also needed to be scalable and easy to use for teachers and principals who are not data experts.
  • I am including this project because I am proud of the enduring value it provides to the organization. I am also proud of this project because it demonstrates the power of collaboration and responding to feedback in service of a better solution. While this work is focused on strategic planning for educational organizations, the principles can apply to any area of commercial or nonprofit activity.
  • For additional project samples, please see the following:

View Example Mentor Dashboard View Example Mentor Dashboard View Example Mentor Dashboard View Example Mentor Dashboard

Powered by Compass Executive Training Program Data Tools

Overview

  • Research & Analysis: I met several times with one of Valor’s executive coaches to better understand the team’s needs. The executive coach also conducted interviews with school principals and administrators so we could build a scalable, user-friendly system.
  • Strategic Planning: Based on the rounds of feedback and user interviews, I focused on designing a user-centric, scalable product, integrating various data metrics through Google Sheets and Apps Script to overcome the challenge of data cohesion.
  • Implementation & Results: I implemented a multi-tiered data structure requiring minimal upkeep after launch, resulting in a scalable, highly praised data management system across all partner schools.

Individual Teacher (Mentor) Dashboard

At the core of Valor’s leadership program is equipping principals and teachers to run “Circle”. Students are required to present three different pieces of social and emotional “work” throughout the year in circle and need to be scheduled evenly. This dashboard creates the student presentation schedule automatically and helps teachers know which students are “on deck” to present in the coming weeks

Example Mentor Dashboard

Click the button to view an example (fake) mentor dashboard. This dashboard is a live view of all the students in a mentoring/advisory course. At schools in Valor’s leadership training program, every student participates in this process. The dashboard also shows the mentor which students are “on deck” to present in the coming weeks and the class’s overall progress toward completing all presentations.

View Example Mentor Dashboard

Evaluation: Teacher Observation (Walkthrough) Form

Valor’s leadership program requires principals to conduct weekly teacher observations (walkthroughs) and provide feedback to teachers on Circle. This form allows principals to quickly enter their observations and feedback–even from their phones–and then stores data in the all-school data systems.

Teacher Observations (Walkthroughs) Dashboard

The Google Form results feed into the principal’s and the teacher’s dashboards immediately after submission. Principals are able to see a reverse-chronological view of all teacher observation (walkthrough) scores on its own tab. This view can aid in tracking long-term teacher development and school-wide trends.

WT Results page

Principal Dashboard

Principals need to support dozens of teachers at running high quality circles as part of the leadership program. Teachers’ individual dashboards feed into the principal dashboard in a simple view. From there, principals can identify which staff members may need more support and can target their efforts accordingly. At the top of the dashboard, principals can track their school’s progress toward end-of-year metrics in a live view.

Principal dashboard

Example Principal Dashboard

Click the button to view an example (fake) principal dashboard. Note: the metrics can sometimes take a minute to load.

View Example Principal Dashboard

Executive Coach (Superadmin) View

Valor’s executive trainers wanted better access to their live data, so I built a third, superadmin tier of the dashboard with all high-level school and teacher data.

Superadmin